SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 664583 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 664583 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821199,843728,103218,896186,685718,406503,594592,783468,773270,490370,621082,53541,256478,997428,678135,104285,351193,705593,282723,18439,242698,541875,887962,59287,446300,964384,611597,638987,595167,693807,946849,170236,113895,188398,47803,427087,756761,667201,247374,48178,171324,804851,507321,851182,406416,992923,571866,130043,65713,511874,266387,128905,992214,738883,841796,764136,113522,594222,303474,944528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 664583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 664583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]