SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002710s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410215 LIMIT 1 [ RunTime:0.002249s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410215 [ RunTime:0.005556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263523,969459,368587,418464,827228,286869,491531,277321,342834,616379,802833,966220,338410,105400,86860,156435,326135,64283,736271,118537,682433,182516,675872,604209,574280,711993,1012136,355370,518069,430699,702781,598120,421510,66718,669078,245081,631193,827025,564190,662495,800667,244900,221181,260593,859843,448722,950345,662590,1042736,706217,791961,328716,42198,696376,745513,174080,504707,178467,662607,139813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000781s ]