SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295316 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295316 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299559,387371,431180,818515,419382,320736,385518,575999,631605,266573,431645,687156,546428,613458,766562,129629,503140,40024,853457,777316,726299,11055,984357,259407,618949,877709,367411,326812,252976,878422,14564,298620,1045899,361279,838422,121617,481886,675063,986423,172480,716725,736261,817286,637834,900404,719412,636677,298587,344023,131445,296387,278702,720407,656059,347650,146839,574214,479542,597991,494404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]