SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500236 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500236 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504184,846808,78132,103816,1044254,274727,693079,264049,435797,790816,33941,636896,198426,364855,307330,627733,144484,1001955,486542,997285,575955,449356,164039,104277,297031,65096,218831,264475,773735,259549,19786,721429,746685,375444,197489,912838,818668,869665,791910,858880,95712,1012590,425318,106429,491823,695083,107573,246593,150203,1017620,143389,277227,212234,733466,347847,376449,828297,664682,296158,809031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]