SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586947 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586947 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578591,492095,730947,669177,37195,754551,915047,402168,189062,883884,16953,315215,1013596,175750,171418,164144,996049,346656,110691,528637,496941,673972,851391,997694,101612,465800,120136,288618,812970,494124,207855,941904,232329,89714,505811,630212,813370,212506,684715,538562,166622,401179,659065,531693,524702,213633,712221,92043,391894,335465,316435,1025094,863438,61540,795786,238060,1007433,939509,732546,732589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]