SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 340148 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 340148 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047791,1019785,607010,584796,810386,16432,1047967,558932,181660,283789,341209,32655,74447,54785,765100,196537,508480,1008021,925205,642762,809467,54052,100072,384671,50033,611504,749926,705587,753975,740053,592204,284052,943260,1023702,1001708,179460,390812,394314,1030721,477386,614950,186230,960307,327918,530791,445656,518702,532796,558297,19209,492047,743722,323667,357139,981734,470126,927535,99108,394338,648548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 340148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 340148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]