SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103522 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103522 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724935,65807,498174,736201,476883,174133,142680,625253,297178,1019633,426523,747736,630008,219576,400581,607035,43689,819382,825418,889537,184328,753203,429609,668864,1041312,333382,157978,102372,1000664,764263,933915,419908,34988,550570,960306,428361,876300,44770,796152,356543,575684,743524,949085,552136,736959,618686,2973,765012,547814,650390,768158,668726,689879,969191,912372,353276,413850,914912,765837,219155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001099s ]