SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346621 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346621 [ RunTime:0.004645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857290,778232,409634,462807,11877,468932,812307,946782,484019,421350,402103,184989,397581,328314,120062,521764,208666,653493,122750,1460,112213,593690,2630,629533,240979,8101,730942,961937,497645,62010,474915,78943,1029378,62164,735601,55422,449715,165449,192022,249953,805303,406359,170092,556652,817611,464130,828214,1040463,58836,503881,133900,650414,132638,433664,316058,60327,827009,315179,10083,889365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]