SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101234 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101234 [ RunTime:0.006431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956866,1027540,693898,529156,901886,661931,451275,1035268,82143,1006174,618961,176284,394976,667854,976813,169790,89000,663482,410632,561349,1004557,595085,107499,126375,267606,1025643,819510,711528,169564,1023765,220476,846730,200680,68572,971754,135505,515952,787344,209530,838433,232108,440665,824332,342360,204723,993938,620841,852912,716013,531577,217784,775798,927264,478088,108276,111456,596502,970328,737628,576824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002691s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002920s ]