SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409074 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409074 [ RunTime:0.002395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135140,509604,23203,904572,293585,962462,831292,1002921,116973,181342,736504,754773,275090,861456,13144,1030594,337683,481729,194548,975886,558579,426222,569993,774908,841627,594805,216041,287608,2577,243062,375134,45478,443166,658783,634666,283942,434199,45112,268022,334827,965533,124121,81056,765197,359404,118608,193092,1031789,611826,57617,328259,364549,822581,967731,1006199,557928,483845,75607,451729,946917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]