SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450185 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450185 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376835,1030533,1043573,139002,330378,662701,439572,543162,735150,803294,741183,779013,1038944,250808,247189,955202,162390,375619,205418,991651,608990,765676,500520,328896,143623,541383,84504,925819,819255,825473,192005,343325,140880,789793,81603,458047,332526,842845,642039,411768,17243,516851,307166,87652,454957,779963,563850,593274,312889,434046,195729,381239,424914,795803,308272,493614,38409,920406,806419,94654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]