SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001690s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200593 LIMIT 1 [ RunTime:0.001578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200593 [ RunTime:0.002699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69729,332167,92713,808685,668702,357217,15020,977946,791181,1038715,633482,366842,115276,859224,466029,853705,30849,887757,111860,81598,184945,684322,874096,982169,15771,46858,802207,769986,894017,209713,170224,678054,606243,607152,93685,789133,921690,598673,828124,261474,736410,553823,324934,235873,544950,461765,11063,813199,540574,265601,511964,886801,1044909,174533,267765,959836,235566,574875,351653,46506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000612s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]