SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421608 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421608 [ RunTime:0.002245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948345,967002,363225,817534,664288,606588,747328,118942,477088,421623,678631,602858,427678,878603,612720,532838,363433,503569,668813,744078,399949,639625,115510,609612,43719,437221,737940,135115,398565,767792,1041072,314377,787256,930668,477543,721927,53792,462739,489769,878620,970200,53732,68538,542325,1015886,894321,695239,588371,1035419,1018690,459649,20179,217953,720378,647816,620055,541904,552894,968319,676566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]