SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31568 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31568 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292071,19279,62613,495847,644655,784009,427378,1028077,1042492,215653,638088,809562,218608,217283,109851,623754,604405,405974,908080,460384,698116,330143,881250,35552,365919,74753,943960,130014,954790,269995,301166,912153,971934,854297,174449,128335,495594,340110,432929,971768,699762,190572,589850,813770,892803,270477,139419,496232,869292,779124,837894,941087,531326,953043,596939,41104,510926,163277,709462,603935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]