SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 365014 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 365014 [ RunTime:0.003166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187464,384065,792270,522092,763221,193536,296056,906025,960291,979699,781735,757556,779242,802643,296063,192958,171080,414454,168133,184942,224300,476110,673107,763058,362786,332441,496202,729764,615225,528444,378126,797534,244927,248597,17843,460631,742709,659064,305079,217755,297361,550137,495641,717300,788086,1004156,432680,370857,853718,974198,423381,507801,850994,230402,409272,940168,82411,376173,82140,273559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 365014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 365014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]