SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340913 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340913 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395448,926659,329578,486619,817027,725367,349852,723206,175613,741066,252240,51046,976082,743373,831001,605124,268366,903018,578317,577373,339244,350886,925935,538602,769827,277923,84349,73437,192800,555231,919606,205275,128062,980834,496213,126809,802800,382229,250096,907420,696765,442578,574490,252130,294323,144125,187233,793299,115381,169168,1011529,1042758,80638,997665,814297,615413,350781,787745,761867,108505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]