SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534251 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534251 [ RunTime:0.005486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164086,364755,723760,927508,1019104,903593,167390,748054,965997,671063,203215,933464,69165,80469,375536,792600,633446,494544,423349,518859,228230,131900,203298,67391,843907,864209,357684,739005,715253,942525,46054,414729,144050,28031,484070,713940,454516,462892,1017021,347247,67941,803783,46146,933433,769352,1007968,701126,185691,204146,1038394,851107,1038148,77720,507395,939812,487800,767988,114698,379032,646213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]