SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150921 LIMIT 1 [ RunTime:0.000762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150921 [ RunTime:0.002191s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54053,252162,740105,388528,343395,224628,100300,276704,372630,162214,282008,752334,958311,215166,508052,749838,452809,110619,284922,679229,103507,43829,106991,100069,829541,97588,286199,502262,811364,847922,272616,235597,178638,512574,377884,726882,129561,819889,387876,958782,504574,58373,47902,287351,81780,245400,773459,6446,651815,396501,850555,813023,998516,730120,264603,306003,482205,768995,663075,243457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000646s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]