SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002722s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503771 LIMIT 1 [ RunTime:0.005350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503771 [ RunTime:0.003048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025833,1012629,393487,708189,383343,976302,139241,685126,330276,192388,1041533,166520,618801,632066,183292,418021,470219,838460,1024622,982172,348444,596620,498705,436998,405106,63065,855139,378065,95432,556665,343298,605999,468667,672591,749097,910775,1019799,838312,121317,95396,510552,531873,515108,733018,351856,443552,3029,299645,79352,923627,750161,2717,1001620,354023,94330,180156,425057,981171,225603,79555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]