SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489678 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489678 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525913,572657,788722,494492,1011183,57033,239610,124639,575295,56837,255662,346180,660054,216955,534183,965891,619527,698839,714462,856394,233643,1034324,357878,598030,656532,818442,978258,796084,376378,689138,853681,426545,606511,431607,763668,232428,145652,776550,344583,339965,423870,639461,661954,177372,823661,673334,609725,872358,674165,688131,234126,1038220,506621,173299,1007530,12022,385399,390998,496085,205120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]