SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427196 LIMIT 1 [ RunTime:0.001506s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427196 [ RunTime:0.004121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033194,399402,121773,334567,961467,1038384,707009,408264,1013854,81640,214986,1026932,329025,200939,957842,107179,1004247,709188,81695,650972,567294,711220,194026,849201,364368,264254,927691,948685,404846,228157,254537,234033,880618,346757,862584,84354,887576,844735,118711,333285,328963,50158,875296,279284,55090,41201,793255,991250,682431,937307,828121,668651,296733,20744,857049,998565,575283,165873,151011,1028956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]