SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154741 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154741 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526887,379600,207725,886177,492547,26601,672764,1003919,1013797,155649,192867,78600,811020,196035,810294,668059,723189,369900,766145,837378,670894,568303,82298,974991,826240,97080,174205,963076,101229,802359,359060,724010,7556,519530,884262,612294,615642,521183,491227,216984,244565,1027714,115102,75715,310935,433681,151814,347188,400273,604637,194169,865605,278790,852061,737729,83010,1014402,902841,647090,583784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]