SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424428 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424428 [ RunTime:0.003091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855119,806819,881460,659623,811801,712166,843939,592797,787412,677605,768919,732123,552961,180615,109095,180029,1044499,489186,634445,183904,109592,820326,96471,903923,367082,353624,194252,392072,941099,640081,269580,1039324,574513,476642,248781,462485,558720,9346,341152,615049,609104,383034,679510,534018,764358,810801,450668,775940,964917,755721,807990,798551,489613,962299,563699,186073,1028917,1018160,1009889,912248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]