SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398427 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398427 [ RunTime:0.006486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030471,546490,1014416,754369,419973,651493,629270,143491,284520,615440,458341,292650,1044547,137267,329881,108070,409650,387562,802431,614682,35743,327117,148647,412746,20962,846755,134569,486330,400969,1024558,496065,153874,740141,537038,320753,320797,354561,592868,878437,256971,708169,182845,256449,1018732,922521,671706,960622,149069,248698,287718,755711,214337,151289,305198,130560,704323,450868,441916,980844,529199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001906s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001128s ]