SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001898s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101880 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101880 [ RunTime:0.003179s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352787,47447,140054,752961,302437,977883,531648,518785,661395,670530,240514,80619,155450,763330,1008064,487065,733854,235138,1010794,758238,537337,487951,810608,491483,85442,122104,360377,420758,938401,239571,682203,182753,703831,454752,425628,8889,814329,411173,586904,887386,605931,942113,319386,19643,342460,835462,242258,817610,701087,1034055,860025,751916,411141,262424,1027922,820838,505975,142378,488071,361831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001001s ]