SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508402 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508402 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491962,329972,729550,678153,928531,245395,55533,24445,559107,1005191,159172,103484,857123,141055,480735,976413,213819,891723,268486,658286,697569,721072,1006659,306386,92430,389719,692908,671265,881185,493487,1013289,337368,836033,661511,624943,530540,815178,264511,792391,693972,366555,366256,581469,207634,233690,624912,127618,386932,448310,973832,1018217,378743,882575,668983,248302,48635,403755,16832,661949,472398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]