SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 964003 LIMIT 1 [ RunTime:0.001642s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 964003 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779581,587763,221749,749916,10163,112020,751604,431977,762666,507826,168564,700456,742608,608551,231839,742895,1041512,253625,199573,427621,622246,408629,416596,559966,402498,737181,161795,154042,763275,994663,916458,292781,770373,274769,759086,886570,963949,361713,811628,277248,1003626,545050,306888,678884,485721,374070,855340,18782,934142,584834,631362,220060,819644,705708,534399,772587,29401,329788,151628,697485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 964003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 964003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]