SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003753s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331928 LIMIT 1 [ RunTime:0.003350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331928 [ RunTime:0.003516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779071,430122,969374,172253,1032803,829791,1043809,80943,142925,639582,866586,747986,894403,157199,1045145,431896,198399,841959,186803,882890,91587,550848,179781,475077,151322,568161,534090,949954,185414,896215,465114,1035126,310785,133228,1015625,215096,578664,24754,943567,1016640,105786,749434,332117,2973,131043,431527,470845,249626,733877,240622,175929,878414,337708,610677,875468,131122,800402,836423,864326,272235) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]