SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010542 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010542 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753700,573723,974162,493229,155430,758149,137919,216008,1010758,744159,46925,136526,442836,563923,895509,791771,598750,94408,929610,778209,762803,620490,112313,773715,273226,243406,25303,271064,674026,1033438,659191,998645,552638,706003,742969,383233,105113,961716,199938,771734,495394,147401,995355,12397,500087,806107,529518,822258,153134,116792,743469,508142,60769,955135,186089,744952,334432,495676,127681,921192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001913s ]