SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003961s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282543 LIMIT 1 [ RunTime:0.000977s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282543 [ RunTime:0.003869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941493,803567,652540,342353,572525,86651,656952,57942,676974,838156,822368,440009,801926,262973,242177,518931,938014,10368,587268,370245,765901,508470,221470,683909,626572,349897,201572,598598,1036122,120878,207894,9019,151315,758414,218904,173769,458388,836404,650798,687003,726107,824487,159041,742954,779906,269485,836465,556986,632914,132743,652530,246121,126472,224353,402951,827392,610119,380557,723756,295300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001895s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]