SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046142 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046142 [ RunTime:0.002969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411467,49734,246311,88041,320170,792932,42138,515250,363037,641855,687915,266822,12968,420803,265409,401695,910643,864704,909457,52150,587466,306631,876461,898638,977774,133723,328293,85992,239984,534163,399696,421546,460744,58112,912970,5845,498636,790390,607184,866915,337527,870642,407112,152406,54627,421642,727119,931829,892593,744903,371716,694324,52229,312279,162853,967900,829418,308430,183408,32269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]