SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 74678 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 74678 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420551,916591,587963,237702,584948,201260,45296,403615,200448,237029,651257,12075,315740,841613,541878,815396,884745,278354,994770,335336,773721,333960,467695,973131,1033221,60977,865052,1022770,546347,787743,715425,149697,123328,45530,514300,332879,757474,1018782,452862,734006,645475,367366,541176,816565,42613,542824,982986,162913,212946,159179,750380,787379,756234,166786,25427,225353,712517,543824,395470,96611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 74678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 74678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]