SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201040 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201040 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696088,890493,788554,998925,572423,766039,434343,693788,801688,711427,374588,295978,276277,467878,129299,196416,85315,38806,270045,935163,28444,528353,446958,705643,85144,987478,457563,767256,700619,190821,420509,234514,911023,625061,135525,784235,865886,530117,1017534,713185,1037635,713212,211986,33645,397576,299377,88679,711395,250391,479962,489714,740083,522631,507428,390878,603842,952527,722244,498478,410939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000913s ]