SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300010 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300010 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351097,577853,998117,328374,528472,381006,863909,824131,507042,285496,484095,656091,764000,586388,1029412,992879,538203,233578,572271,646947,648295,586594,191143,837255,199035,568318,345674,724383,305206,765056,1004370,345756,699567,918545,880758,532607,273130,49825,542117,69926,915872,956212,378531,707205,256030,38238,424470,203251,105871,153096,875553,220673,713261,164070,157510,626191,973850,75280,1002229,773795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]