SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335771 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335771 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938064,622556,713501,844629,954172,405079,353853,618102,122937,388837,622734,335838,838719,659737,980562,326764,51603,69190,488227,1037322,144990,862535,227583,875759,109373,353274,571845,475490,753516,206763,260545,385144,243752,927114,240758,259835,586911,891923,1003884,823581,41084,992642,277185,474768,466570,241831,951557,589287,142211,485326,154073,609973,511052,405041,342457,967846,294444,307752,735971,601152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]