SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314203 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314203 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816826,526789,196942,868408,791388,944115,771263,816681,298232,92299,423267,303336,172880,413932,8554,572790,934036,709911,828288,255569,197213,116090,274919,549279,676810,959235,711804,553020,961137,297937,998591,404260,499827,391233,226432,425992,112810,210008,739063,259077,488642,352326,283490,331816,845989,113377,248541,612193,545762,988718,212897,796491,1027,736791,686370,458432,172853,1030097,1014961,782731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]