SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579852 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579852 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133596,830879,850902,825417,611649,1038069,767831,207963,253814,826770,37489,969303,790394,454309,715337,793593,812372,833865,140900,409266,604925,496437,575697,765918,524883,419485,607546,894601,424718,324220,159928,587654,696967,678753,924500,946766,67847,991360,1029726,170531,276528,430353,775889,79282,134518,930526,519484,484144,760046,331160,504817,216715,194390,218808,738115,986541,437128,351379,768232,644274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]