SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516918 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516918 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407761,437651,902835,715178,933020,17266,67014,570594,471339,865456,755141,440176,79857,873605,255382,627876,517201,1022579,620686,299138,537349,984866,520439,656755,991348,299400,881453,1132,311522,608492,761321,796699,995813,571249,985267,11028,635797,307451,896007,158151,32683,700879,307531,523659,307428,912769,287162,148881,417688,519750,59380,182057,898210,128441,142380,311133,597041,1033340,945377,145474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001833s ]