SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010228 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010228 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486659,122111,912534,284210,952891,505506,166561,307324,89072,207630,163548,523685,661667,647984,386314,612196,778618,1015971,773318,310710,815176,28251,785219,738918,118292,388276,614517,211473,317510,50767,1037231,450471,461425,894739,717615,441006,754012,780276,809849,89879,361737,748123,262086,170421,290180,135195,815602,178362,524449,597513,271705,361845,467237,460168,484201,619527,699708,654166,491411,328556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]