SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981505 LIMIT 1 [ RunTime:0.000933s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981505 [ RunTime:0.003747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7041,285696,504285,993648,85927,562331,96303,817307,267687,648798,670921,199287,752019,591047,183412,779057,442362,648133,144038,754024,303691,897460,676921,390142,746381,970818,533321,113945,656939,813472,546115,776407,734660,523306,818173,229646,907031,596543,397390,305920,186962,1041185,249191,217393,553725,132618,672210,928718,337158,625012,716031,873518,218226,291985,341023,331266,938125,844321,626768,633502) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]