SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175071 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175071 [ RunTime:0.002345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512217,105908,604584,558725,542271,912486,530904,565991,126394,868707,407730,4257,782616,1016835,991487,582285,248045,872623,915342,508472,927809,167719,636095,14916,823598,435019,45451,142784,539319,463850,562575,198512,354317,797006,447527,687911,71808,429616,744033,424240,777175,192919,830762,325807,479207,678290,235919,735312,915284,741374,446020,294868,150905,244389,30708,916677,182491,875218,713709,535090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]