SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 127212 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 127212 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102303,686780,1003280,749695,609335,609556,540039,738347,662701,1044896,333686,81098,439409,210441,500525,250234,719325,1048615,790828,232600,935771,307886,296177,176012,968408,817996,474312,516168,29060,597574,794350,115158,207210,758774,103264,570745,705816,621928,155247,117091,1006790,953284,422161,493603,350033,35353,677748,2825,754773,364451,883436,124345,728306,772988,937620,1031484,652121,505209,486888,942092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 127212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 127212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]