SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038112 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038112 [ RunTime:0.002124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988533,450886,920041,15014,515012,54498,356643,304030,436734,466832,604263,212097,529030,281922,880950,921841,39549,605707,822649,326292,592758,385657,503012,521491,671444,16338,828643,64512,878537,603083,868019,513726,143715,200558,396172,740842,610223,869344,786455,260826,671076,53451,941680,9897,1009475,474737,830002,6326,259287,474996,352252,695522,929917,902534,876260,497547,438012,48523,198057,154108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]