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` = 443162 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443162 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (170515,683193,867995,989352,1046385,1008611,400419,736043,448753,25867,629723,517160,697909,550960,1043399,120267,949457,273605,244544,652877,323476,44711,159190,143863,465740,137643,567540,105244,517116,643004,741906,818230,640663,882412,941415,604812,944883,1018063,65576,135983,1014758,14140,489510,1019150,274181,1036684,194190,337367,501576,191057,611193,354616,248960,838567,252470,30873,1010020,156693,161515,491455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]