SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472518 LIMIT 1 [ RunTime:0.000907s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472518 [ RunTime:0.003090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245307,664612,502413,613683,825599,359351,739151,534612,713990,930194,922880,587301,31423,694278,944690,145140,61756,579594,557870,178127,676540,94210,49151,510680,261262,251280,922980,190105,972794,12625,990668,316631,166155,379653,521798,792840,291039,607542,525635,1011119,928270,76425,30390,471609,444995,837710,804581,284928,148352,620213,14956,322360,340628,239720,490398,778550,255208,69600,582422,195872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]