SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450304 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450304 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599220,193116,463553,648184,62885,409234,861550,311361,250123,32018,670847,69731,128882,572388,585581,534446,663434,36753,621149,44757,25726,667023,698822,450337,712467,1011762,140011,238916,353307,228977,55177,967971,835170,110118,36945,1032319,728582,419872,334893,8841,105463,670013,180436,269381,948228,637239,287918,894885,138686,355615,583210,612005,588447,459547,553706,417025,1015417,771285,803035,544688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450304 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450304 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]