SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580988 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580988 [ RunTime:0.002902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186537,515139,103222,98852,742362,564695,769545,823813,771225,313412,473750,206408,749356,759984,724858,990277,923859,514079,239162,137845,38434,907578,358386,992527,367801,270784,165876,695435,132389,37717,781022,893511,573252,465221,949613,76611,871740,299475,452556,634472,298658,722113,55620,140866,519765,646343,1047894,992720,551646,710638,749712,830976,157909,511376,148350,840232,66394,957058,967706,602863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]