SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034407 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034407 [ RunTime:0.006890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034230,337897,160033,222066,561826,494399,180354,612490,439151,86557,62240,926166,141344,177952,795147,293323,117000,282629,4536,785802,475898,823335,710424,174916,682775,257896,18410,1041501,280851,548308,958942,98123,404740,69868,212760,530601,259396,670213,912559,18975,51974,38723,471778,484563,678996,11415,666502,517634,250856,1014963,981970,78939,130534,28623,355417,16914,65302,957479,14133,679516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]