SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100218 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100218 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998386,220417,344071,600027,1041709,511613,810333,170737,1007802,401612,301055,753144,277820,336741,470729,53862,919798,908025,472641,474434,92205,669133,382624,533956,770085,581619,213774,104548,92189,506670,854890,828412,763246,18048,663673,56062,317240,66056,811826,741978,368033,527712,732060,16625,787469,149565,48774,1011249,964605,516989,145715,473658,680740,273057,527632,242970,1026805,870203,965019,1023810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]