SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58581 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58581 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876072,101398,691650,148008,827582,730366,214590,548258,109035,116638,594226,904451,988818,507046,643530,129884,1034897,1025063,276672,1009721,459220,321696,739551,136234,778499,750938,32349,422008,572922,323276,344670,121540,289391,73402,799325,544017,878388,690977,707220,942806,449471,555522,948256,374683,1025084,418229,44045,556941,980847,718080,1023079,31334,926602,425703,117089,563741,660266,677098,318583,604238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]