SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 930952 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 930952 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102843,1030509,361785,493003,189070,1029715,39120,191258,821354,990880,978662,590171,427343,288628,526561,912804,68867,744538,406445,705040,133026,269031,1984,46148,743288,762399,878556,127004,575229,726237,368064,384407,534702,110368,774208,605811,603847,112103,827540,627337,279281,489608,213865,600146,172119,577113,163535,902239,1017067,373404,227761,1030920,296493,409401,656196,629066,664071,986560,729565,221017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004626s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 930952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 930952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]