SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421216 LIMIT 1 [ RunTime:0.000920s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421216 [ RunTime:0.002984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487255,650646,201284,461452,805336,117423,827576,114035,288066,33800,124250,896195,45340,168609,807967,900423,797743,111926,221230,277223,243869,811909,892023,95300,375278,199988,630109,1035798,554098,494813,817296,241224,385949,105956,615770,806007,70878,930134,548409,496421,271923,556417,456355,973698,714536,821178,627213,511029,661977,828606,467130,778268,814072,741718,990144,783100,193570,976931,192305,269857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]