SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458901 LIMIT 1 [ RunTime:0.001573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458901 [ RunTime:0.006536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039549,1016043,324395,282811,691024,255596,240374,394336,245478,784156,525649,70659,743954,37496,814687,51179,38300,346729,261042,338301,536538,1026464,298157,998085,170094,466620,312684,190952,508326,952869,505062,509841,945360,1047660,536411,562530,348436,845036,709101,601351,567790,300825,847265,892800,59719,834218,535277,443647,318985,563343,851774,372031,375765,951751,122568,912475,748978,96019,859954,772589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]