SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460758 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460758 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28308,656428,424356,163625,291582,612393,742131,562114,567239,361832,131515,140465,999296,120299,953815,637860,773781,946133,470185,491459,587418,161745,80109,360609,249836,331508,874942,920363,453410,226088,712742,649798,868720,790787,554864,645145,450370,1027639,413635,914972,12739,792129,29158,376621,873358,139954,321779,709231,537540,377622,316994,905630,776512,359005,958625,590642,36918,57031,935100,104020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]