SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342217 LIMIT 1 [ RunTime:0.003266s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342217 [ RunTime:0.001408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716005,880081,988787,350712,645585,1005098,870066,273662,179108,459839,349472,951046,520658,1037617,18575,991608,363688,946037,166599,712600,653267,1017464,298386,710406,392390,657232,890362,246333,919847,434380,605425,501710,249519,342978,343504,880927,314189,551345,808676,542998,534999,354819,751120,757036,810227,6053,974332,648674,953990,428185,775525,75457,809920,206980,478025,857762,1047509,1014540,13110,365035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002765s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]