SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281463 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281463 [ RunTime:0.008158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249792,306794,718435,616161,957806,306015,704503,963678,228586,143544,502943,537741,115912,968293,192946,133087,31508,245885,254212,659092,168442,159045,461975,235210,367461,1036253,20110,398695,570177,149902,87634,695118,147424,471458,510996,432008,579106,419843,186155,557572,653675,852011,995387,524614,210867,351564,979242,634201,555070,907424,848211,358558,424167,1038050,875995,525873,924322,26362,266040,242444) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]