SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502655 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502655 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82352,845841,556282,1035686,800297,312779,565054,360077,273874,269799,539969,349897,967139,277443,235849,269347,651572,259341,60142,560145,463869,132314,163357,627103,760202,1016766,992760,662003,548003,198266,188438,460219,713347,419333,300233,855751,711376,203093,1046338,95226,147562,864513,91257,296638,947955,804660,940279,849221,586140,281027,8245,674065,733062,959015,786667,839315,97168,412933,50492,447745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502655 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502655 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]