SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506294 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506294 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219969,791599,255108,577520,326807,807056,230503,390197,576794,728722,591119,754292,448073,1027250,137647,31413,887176,307859,146852,219278,327398,193687,448769,570223,468733,1025248,16681,648516,875292,623484,500287,1021954,486980,496271,202652,898306,593425,349273,417090,13229,345179,198352,178574,408194,906656,424476,221785,958710,1020212,59934,994075,201742,155346,612127,847838,611875,389317,195397,509990,754730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000742s ]