SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904346 LIMIT 1 [ RunTime:0.003727s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904346 [ RunTime:0.003099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438096,1010257,983019,191307,457016,410870,384535,386196,266970,360024,512017,627603,490014,811803,113636,722778,175942,1030493,218467,207093,928231,125576,367189,381942,403074,508834,563005,233153,409960,678661,775985,294212,621995,1044399,646734,493828,940132,546243,191766,83396,369947,167610,649229,452668,680142,724273,501306,756689,859551,266222,114896,936600,503744,672556,285539,937615,81947,672387,971484,851814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]