SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200627 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200627 [ RunTime:0.004172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476681,863035,67654,190658,996378,25068,594626,762665,922414,972985,512812,601473,383831,925766,978110,435401,351518,723091,622839,209428,859926,274533,849642,1007257,9244,127867,912659,483803,1039622,534568,139764,589381,352115,744585,125529,72921,889060,471083,293006,341469,1048695,789591,803760,918518,117639,873963,245004,992622,431861,32844,550801,725297,677531,54030,508349,77983,931096,898461,817974,196127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]