SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265047 LIMIT 1 [ RunTime:0.000870s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265047 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024890,504072,792069,829186,790003,692036,203569,990932,592255,307461,97973,685800,116048,88474,580277,532003,475959,306966,370179,520885,911289,746288,537110,166157,464470,907378,633497,10442,241428,76559,700075,117212,1043858,119414,245153,311170,691670,664899,608321,253591,698778,803538,697567,942988,259613,555455,627363,894145,579625,637296,989551,621468,927342,960029,1035179,755090,449121,75822,607373,907209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000901s ]