SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 24690 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 24690 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224391,167770,1009949,1009104,404194,647059,163732,413243,601140,430554,191225,566612,376131,320418,424674,1018459,100960,459558,82844,391018,540063,1005360,736988,800358,592682,549444,550747,504891,828041,778336,677258,485057,601573,487640,950251,101531,390888,872286,90362,304098,199334,541604,925448,248944,370560,94612,189731,261959,942911,69071,392678,451568,1013039,448189,827497,69929,395968,161178,251244,807953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 24690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 24690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]