SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195294 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195294 [ RunTime:0.002647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115504,731814,482312,770863,792741,195511,78096,930129,703304,70587,61628,39150,203509,527125,762746,1039725,854212,597664,369900,278311,894,720596,847549,888512,714938,653711,831337,334085,377008,604089,316682,600440,971594,450567,487599,325661,189094,464583,494202,682439,667470,372788,965772,461672,374071,290183,221795,758916,180669,370254,116922,264884,575131,1010755,910282,916027,96616,312616,104859,378632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001241s ]