SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521035 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521035 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172430,369116,490235,391929,633803,490105,114627,653838,433906,832929,164893,929133,44320,58557,846751,12323,568443,852032,512438,426703,914376,944592,552959,632204,252794,331598,210701,864954,133859,506195,998175,872292,56195,859058,691306,435139,57142,338416,834038,835393,245045,406762,60817,577082,894264,182952,474005,1040986,564934,212927,42751,201862,188739,692509,939950,309565,690978,401463,1015736,195968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]