SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520700 LIMIT 1 [ RunTime:0.002055s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520700 [ RunTime:0.007886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647180,3904,702550,868731,676695,890161,924523,48488,126077,184048,411469,999624,237055,772708,113210,349780,1011782,864255,220204,846066,440531,562769,968501,488944,190705,472789,179625,964838,552897,599662,507092,341098,220849,165994,780552,546270,923083,179157,957821,390429,707812,269580,484556,490803,679875,804410,680956,698142,63064,405144,750418,384305,344493,163994,569870,662125,647144,805116,696864,720636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002718s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000747s ]