SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548583 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548583 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746671,540032,279245,792901,210737,355719,745427,1041538,380705,447552,935301,958460,976880,693886,503823,517606,741663,485594,611620,199403,722016,22058,416404,446568,870774,576389,469809,620568,22132,2278,22202,14435,823945,603798,595412,795162,538568,358142,542843,903815,54489,96858,65654,875565,654519,640141,562298,699076,655011,200130,158822,981692,96406,141504,1010941,665941,802806,796866,518594,717126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]