SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000888s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689365,751426,260249,177191,839875,12260,836807,426217,421797,299567,235316,317379,547544,781796,414296,231350,35042,533436,300569,283713,63887,98780,603674,516877,117161,848364,467548,633945,1001980,717077,121952,507412,350392,1022770,322576,572051,176265,653254,480651,179163,160436,11125,681144,332558,507624,1011670,269600,681555,64592,71795,172780,189852,483233,752489,376917,188937,185007,1036940,817743,866169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]